Auto Fill Range
AutomatR.Excel.Activities.AutoFillRange
The "Auto Fill Range" activity in AutomatR is part of the Excel activities package, providing functionality to mimic the Autofill functionality in Excel. This activity is useful for automatically adapting formulas from a source range to a destination range based on the specified rule.
Properties
| Name | Description |
|---|---|
| Input | |
| Destination Range | Specifies the range that gets autofilled based on the specified rule from the source range. |
| Source Range | Specifies the range containing the autofill rule. Formulas defined in this range will be adapted to the destination range. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Auto Fill Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Auto Fill Range" activity onto the workflow.
- Configure the properties by specifying the source range containing the autofill rule and the destination range to be autofilled.
- Optionally, configure the delay.
- Execute the workflow to apply the autofill rule to the destination range based on the specified source range.
Example: Consider an example where the "Auto Fill Range" activity is used to autofill formulas from the range "A1:A5" to the destination range "B1:B5":
Auto Fill Range:
Source Range: "A1:A5"
Destination Range: "B1:B5"
Delay: 2
In this example, the activity adapts the formulas defined in the source range "A1:A5" to the destination range "B1:B5." The optional delay is set to 2 seconds, providing time for any necessary synchronization.